Sessions by type

The Sessions view lists sessions per the selected type, such as all blocking sessions, and provides a summary of their current status.

Each session summary includes the following metrics:

• Session ID (per SQL Server)
• Name of the database user whose credentials are being used to execute statements or operations on this server
• Name of the database being used by this session
• Name of the application or job that initiated this session
• Total amount of I/O – disk reads and writes — initiated by actions taken during this session
• Total amount of CPU time required to process actions taken during this session
• Total amount of memory (number of cached pages) that is allocated to this session

How do I get more detailed information about a specific session?

To view details such as the session properties and status, tap the session about which you what more information.

What types of sessions can I view?

You can view:

• All active sessions
• All blocked sessions
• All blocking sessions
• Any session that is caught in a blocking chain
• Top 10 sessions consuming the most CPU
• Top 10 sessions consuming the most I/O
• Top 10 sessions consuming the most memory
• Top 10 sessions that are waiting for a resource

How do I switch to a different session type?

Click Back to navigate to the Details tab on the Sessions view.

How do I interpret the blocking chain?

The block chain view displays an interactive, hierarchical list of the order in which sessions are currently blocked. The list starts with the lead blocker, or the root blocking session, and expands to display the subsequently blocked sessions. In this way, you can quickly see the relationships between blocking and blocked sessions, and determine how extensive the block actually is.

You can expand the list to the exact level of the session in question. To view details about a blocked or blocking session, tap the session about which you what more information.

Why is the number of sessions listed different than what was cited on other views?

In SQLdm Mobile, session performance metrics, including the number of sessions, are collected and displayed in real-time as you navigate from view to view. For example, if some time passed before you navigated to this view from the Sessions dashboard, it is possible that some sessions closed or opened or changed status, causing the displayed list to be different than what you expected. This discrepancy can occur because the connection lifespan of a session is typically brief.